Tabela PhTradeDocAccountDef

Definicja tabeli PhTradeDocAccountDef

Name

PhTradeDocAccountDef

Code

PhTradeDocAccountDef

Comment

Account definitions for trade documents


Lista kolumn tabeli PhTradeDocAccountDef

Name

Code

TradeDocAccountDefID

TradeDocAccountDefID

accountCreditDef

accountCreditDef

accountDebitDef

accountDebitDef

Active

Active

reverseSign

reverseSign

fromDt

fromDt

toDt

toDt

StID

StID

Registry

Registry


Kolumna TradeDocAccountDefID tabeli PhTradeDocAccountDef

Definicja kolumny TradeDocAccountDefID tabeli PhTradeDocAccountDef

Name

TradeDocAccountDefID

Code

TradeDocAccountDefID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID Account definition for trade documents


Kolumna accountCreditDef tabeli PhTradeDocAccountDef

Definicja kolumny accountCreditDef tabeli PhTradeDocAccountDef

Name

accountCreditDef

Code

accountCreditDef

Data Type

VARCHAR2(255)

Mandatory

No

Comment

credit account definition


Kolumna accountDebitDef tabeli PhTradeDocAccountDef

Definicja kolumny accountDebitDef tabeli PhTradeDocAccountDef

Name

accountDebitDef

Code

accountDebitDef

Data Type

VARCHAR2(255)

Mandatory

No

Comment

debit account definition


Kolumna Active tabeli PhTradeDocAccountDef

Definicja kolumny Active tabeli PhTradeDocAccountDef

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

active


Kolumna reverseSign tabeli PhTradeDocAccountDef

Definicja kolumny reverseSign tabeli PhTradeDocAccountDef

Name

reverseSign

Code

reverseSign

Data Type

NUMBER(3)

Mandatory

Yes

Comment

account has reverse sign


Kolumna fromDt tabeli PhTradeDocAccountDef

Definicja kolumny fromDt tabeli PhTradeDocAccountDef

Name

fromDt

Code

fromDt

Data Type

DATE

Mandatory

Yes

Comment

active from date


Kolumna toDt tabeli PhTradeDocAccountDef

Definicja kolumny toDt tabeli PhTradeDocAccountDef

Name

toDt

Code

toDt

Data Type

DATE

Mandatory

No

Comment

active to date


Kolumna StID tabeli PhTradeDocAccountDef

Definicja kolumny StID tabeli PhTradeDocAccountDef

Name

StID

Code

StID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

stock id


Kolumna Registry tabeli PhTradeDocAccountDef

Definicja kolumny Registry tabeli PhTradeDocAccountDef

Name

Registry

Code

Registry

Data Type

VARCHAR2(8)

Mandatory

No

Comment

Kolumna przechowuje informacje o rejestrze ksiegowym


Lista kluczy tabeli PhTradeDocAccountDef

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhTradeDocAccountDef

Definicja klucza Identifier_1 tabeli PhTradeDocAccountDef

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment